Aside

logo

Contact

Language Skills

R
Javascript (d3.js)
C++
Python
Bash
SQL

Disclaimer

Made w/ pagedown.

Source code adapted with gratitude from: github.com/nstrayer/cv.

Last updated on 2020-06-10.

Main

Kyle McGillicuddy-Penna

I have made visualizations viewed by hundreds of thousands of people, sped up query times for 25 terabytes of data by an average of 4,800 times, and built packages for R that let you do magic.

Currently searching for a position that allows me to build tools leveraging a combination of visualization, machine learning, and software engineering to help people explore and understand their data in new and useful ways.

Skills

Communication:

action oriented translator.

N/A

N/A

  • Proven ability to connect with stakeholders across functions, teams, and experience levels.
  • Practiced listener, precise speaker, analytical thinker.
  • Eliminate vagueness, even while describing complexity or uncertainty.
  • Ask hard questions and push for answers that drive improvements.
  • Graphical communication via Tableau, R, Excel.

Data access:

experienced SQL writer, reader, and editor.

N/A

N/A

  • PLSQL package development.
  • Query optimization in a medium to large (billion row, non-distributed) data setting.

Data analysis:

R to read, wrangle, explore, visualize, and model, mostly via the tidyverse.

N/A

N/A

Data storage (warehousing + ETL) via:

N/A

N/A

N/A

  • Dimensional modeling: star + snowflake schemas + Kimball best practices.
  • Database design: table creation and data normalization, data typing, constraints, indexes.
  • PLSQL: scheduler + packages + triggers + stored procedures.
  • Pentaho’s Data Integration.
  • Cron + shell scripts.

Education

B.A. in Engineering Psychology

Tufts University

Medford & Boston, Massachusetts.

2004 - 2000

  • Honors, Dean’s List.

Selected Positions

YOU Technology

Business Intelligence Lead

N/A

2020 - 2010

  • Focus on scaling data resources to support 100%+ yearly customer and revenue growth over multiple years.
  • Own data related product development process: ensure clear and achievable requirements, leading to better tools to inform decision makers.
  • Hire, manage, and mentor a small team of engineers and analysts.

YOU Technology

Senior Business Analyst

N/A

2010 - 2006

  • Collaborate with management to identify, track, and present best metrics of business impact; present those metrics to team leaders via executive dashboards.
  • Build and maintain data warehouse and client facing reporting site to allow retailers to independently monitor and analyze campaigns.